Using the FTP Assigned Rate Budget utility

This planning utility calculates FTP and annualized FTP for balance sheet accounts that are not budgeted in plan files (plan file balance sheet calculation methods are enabled to calculate FTP).

Posting calculated and annualized FTP amounts to the database

IMPORTANT: Make sure that accounts under the Other balance sheet accounts not assigned to a calc method section of the Balance Sheet Projection drivers are assigned FTP rates. This utility references the interest bearing map for the FTP rate assigned to the accounts. It will also look up the FTP rate from the Interest Rate driver. You will not be able to process this utility until these drivers are configured.

NOTE: This functions only if enable FTP for your budget or forecast.

To save FTP amounts to the database:

1. Open a budget, scenario, or forecast.

2. From the Plan Utilities tab, click FTP Assigned Rate Budget Utility from the list of planning utilities.

   NOTE: The utility opens in the Desktop Client.

3. In the Main ribbon tab, click Refresh.

   

   Click image to view full size

4. In the Refresh Variables dialog, click Choose Value, select the company, and click OK.

   NOTE: The query on the Report sheet displays average balances and calculates FTP and ANNFTP.

5. To save the FTP amounts to the database, in the Main ribbon tab, click Save.
6. When you are done, close the utility.

Processing calculations and annualized FTP amounts for a budget

To process calculations and annualized FTP for a budget:

1. Open a budget, scenario, or forecast.

2. Click the Plan Utilities tab.

3. Do one of the following:

   • To process only this utility, in the Process Plan Utilities column, locate FTP Assigned Rate Budget Utility in the list, and click Process.

   • To process all planning utilities, click Process All.

TIP: Axiom will notify you when your scheduled job is completed. for more information, see Viewing notifications in the Web Client.